from wxauto import WeChat
import pandas as pd

# 创建WeChat对象
wx = WeChat()

# 读取Excel文件
df = pd.read_excel("./接收人.xlsx")

# 逐行发送文件
for index, row in df.iterrows():
    friend_name = row['FriendName']
    file_path = row['FilePath']
    wx.SendFiles(file_path, friend_name)
